Dataset info
| Number of variables | 39 |
|---|---|
| Number of observations | 1211 |
| Missing cells | 2976 (6.3%) |
| Duplicate rows | 0 (0.0%) |
| Total size in memory | 1.2 MiB |
| Average record size in memory | 1.0 KiB |
Variables types
| NUM | 26 |
|---|---|
| CAT | 13 |
Reproduction info
| Date of analysis | 2020-02-08 11:57:37.515139 |
|---|---|
| Version | pandas-profiling v2.4.0 |
| Command line | pandas_profiling --config_file config.yaml [YOUR_FILE.csv] |
| Download Configuration | config.yaml |
Warnings
%_Weight has 63 (5.2%) missing values | Missing |
Accrued_Interest has 63 (5.2%) missing values | Missing |
Accrued_Interest has 13 (1.1%) zeros | Zeros |
Asset_Swap_Spread has 63 (5.2%) missing values | Missing |
Cash has 63 (5.2%) missing values | Missing |
Cash has 1122 (92.7%) zeros | Zeros |
Currency has constant value "GBP" | Rejected |
Cusip has a high cardinality: 1211 distinct values | Warning |
Description has a high cardinality: 562 distinct values | Warning |
Duration_To_Worst has 63 (5.2%) missing values | Missing |
Effective_Yield has 63 (5.2%) missing values | Missing |
Excess_Rtn_%_MTD has 63 (5.2%) missing values | Missing |
Face_Value has 63 (5.2%) missing values | Missing |
Illiquidity_Premium has 1150 (95.0%) missing values | Missing |
ISIN has 51 (4.2%) missing values | Missing |
ISIN has a high cardinality: 1159 distinct values | Warning |
Maturity has a high cardinality: 983 distinct values | Warning |
OAS_vs_Govt has 63 (5.2%) missing values | Missing |
OAS_vs_Swap_ has 63 (5.2%) missing values | Missing |
Prior_Month-End_%_Weight has 64 (5.3%) missing values | Missing |
Prior_Month-End_Accrued_Interest has 64 (5.3%) missing values | Missing |
Prior_Month-End_Asset_Swap_Spread has 64 (5.3%) missing values | Missing |
Prior_Month-End_Duration_To_Worst has 64 (5.3%) missing values | Missing |
Prior_Month-End_Effective_Duration has 64 (5.3%) missing values | Missing |
Prior_Month-End_Effective_Yield has 64 (5.3%) missing values | Missing |
Prior_Month-End_OAS_vs_Govt has 64 (5.3%) missing values | Missing |
Prior_Month-End_OAS_vs_Swap has 64 (5.3%) missing values | Missing |
Prior_Month-End_Price has 63 (5.2%) missing values | Missing |
Prior_Month-End_Yield_To_Worst has 64 (5.3%) missing values | Missing |
Sector_Level_1 has 63 (5.2%) missing values | Missing |
Sector_Level_2 has 63 (5.2%) missing values | Missing |
Sector_Level_3 has 63 (5.2%) missing values | Missing |
Sector_Level_4 has 63 (5.2%) missing values | Missing |
Sector_Level_4 has a high cardinality: 65 distinct values | Warning |
Ticker has 63 (5.2%) missing values | Missing |
Ticker has a high cardinality: 428 distinct values | Warning |
TRR_%_MTD_LOC has 63 (5.2%) missing values | Missing |
Type has 63 (5.2%) missing values | Missing |
Yield_to_Worst has 63 (5.2%) missing values | Missing |
Effective_Duration is highly correlated with Duration_To_Worst and 2 other fields | High Correlation |
Duration_To_Worst is highly correlated with Effective_Duration and 2 other fields | High Correlation |
Effective_Yield is highly correlated with Asset_Swap_Spread and 8 other fields | High Correlation |
Asset_Swap_Spread is highly correlated with Effective_Yield and 8 other fields | High Correlation |
Face_Value is highly correlated with %_Weight and 1 other fields | High Correlation |
%_Weight is highly correlated with Face_Value and 1 other fields | High Correlation |
OAS_vs_Govt is highly correlated with Asset_Swap_Spread and 8 other fields | High Correlation |
OAS_vs_Swap_ is highly correlated with Asset_Swap_Spread and 8 other fields | High Correlation |
Prior_Month-End_%_Weight is highly correlated with %_Weight and 1 other fields | High Correlation |
Prior_Month-End_Accrued_Interest is highly correlated with Accrued_Interest | High Correlation |
Accrued_Interest is highly correlated with Prior_Month-End_Accrued_Interest | High Correlation |
Prior_Month-End_Asset_Swap_Spread is highly correlated with Asset_Swap_Spread and 8 other fields | High Correlation |
Prior_Month-End_Duration_To_Worst is highly correlated with Duration_To_Worst and 2 other fields | High Correlation |
Prior_Month-End_Effective_Duration is highly correlated with Duration_To_Worst and 2 other fields | High Correlation |
Prior_Month-End_Effective_Yield is highly correlated with Asset_Swap_Spread and 8 other fields | High Correlation |
Prior_Month-End_OAS_vs_Govt is highly correlated with Asset_Swap_Spread and 8 other fields | High Correlation |
Prior_Month-End_OAS_vs_Swap is highly correlated with Asset_Swap_Spread and 8 other fields | High Correlation |
Prior_Month-End_Price is highly correlated with Price | High Correlation |
Price is highly correlated with Prior_Month-End_Price | High Correlation |
Prior_Month-End_Yield_To_Worst is highly correlated with Asset_Swap_Spread and 8 other fields | High Correlation |
TRR_%_MTD_LOC is highly correlated with Excess_Rtn_%_MTD | High Correlation |
Excess_Rtn_%_MTD is highly correlated with TRR_%_MTD_LOC | High Correlation |
Yield_to_Worst is highly correlated with Asset_Swap_Spread and 8 other fields | High Correlation |
Sector_Level_2 is highly correlated with Sector_Level_1 and 2 other fields | High Correlation |
Sector_Level_1 is highly correlated with Sector_Level_2 and 2 other fields | High Correlation |
Sector_Level_3 is highly correlated with Sector_Level_1 and 2 other fields | High Correlation |
Sector_Level_4 is highly correlated with Sector_Level_1 and 2 other fields | High Correlation |
| Distinct count | 1076 |
|---|---|
| Unique (%) | 88.9% |
| Missing | 63 |
| Missing (%) | 5.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.08710797909407665 |
|---|---|
| Minimum | 0.016059999999999998 |
| Maximum | 0.82883 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 9.6 KiB |
Quantile statistics
| Minimum | 0.01606 |
|---|---|
| 5-th percentile | 0.02903 |
| Q1 | 0.0484075 |
| median | 0.06759 |
| Q3 | 0.1027625 |
| 95-th percentile | 0.2123205 |
| Maximum | 0.82883 |
| Range | 0.81277 |
| Interquartile range (IQR) | 0.054355 |
Descriptive statistics
| Standard deviation | 0.06786320703 |
|---|---|
| Coefficient of variation (CV) | 0.7790699283 |
| Kurtosis | 26.3033107 |
| Mean | 0.08710797909 |
| Median Absolute Deviation (MAD) | 0.04343968951 |
| Skewness | 3.829608474 |
| Sum | 99.99996 |
| Variance | 0.004605414868 |
| Value | Count | Frequency (%) | |
| 0.06243 | 4 | 0.3% | |
| 0.04309 | 3 | 0.2% | |
| 0.051 | 3 | 0.2% | |
| 0.05906 | 3 | 0.2% | |
| 0.04315 | 3 | 0.2% | |
| 0.06749 | 3 | 0.2% | |
| 0.05093 | 3 | 0.2% | |
| 0.04293 | 3 | 0.2% | |
| 0.10906 | 2 | 0.2% | |
| 0.04275 | 2 | 0.2% | |
| Other values (1065) | 1119 | 92.4% | |
| (Missing) | 63 | 5.2% |
| Value | Count | Frequency (%) | |
| 0.01606 | 1 | 0.1% | |
| 0.01692 | 2 | 0.2% | |
| 0.01694 | 2 | 0.2% | |
| 0.01697 | 1 | 0.1% | |
| 0.01701 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 0.82883 | 1 | 0.1% | |
| 0.7521 | 1 | 0.1% | |
| 0.56121 | 1 | 0.1% | |
| 0.51739 | 1 | 0.1% | |
| 0.49136 | 1 | 0.1% |
| Distinct count | 1069 |
|---|---|
| Unique (%) | 88.3% |
| Missing | 63 |
| Missing (%) | 5.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.7460923667247388 |
|---|---|
| Minimum | 0.0 |
| Maximum | 7.247917 |
| Zeros | 13 |
| Zeros (%) | 1.1% |
| Memory size | 9.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.11851045 |
| Q1 | 0.55042825 |
| median | 1.239726 |
| Q3 | 2.64922975 |
| 95-th percentile | 4.76787685 |
| Maximum | 7.247917 |
| Range | 7.247917 |
| Interquartile range (IQR) | 2.0988015 |
Descriptive statistics
| Standard deviation | 1.52282784 |
|---|---|
| Coefficient of variation (CV) | 0.8721347561 |
| Kurtosis | 0.5440143138 |
| Mean | 1.746092367 |
| Median Absolute Deviation (MAD) | 1.233673115 |
| Skewness | 1.091358001 |
| Sum | 2004.514037 |
| Variance | 2.319004631 |
| Value | Count | Frequency (%) | |
| 0 | 13 | 1.1% | |
| 0.215753 | 3 | 0.2% | |
| 2.794521 | 3 | 0.2% | |
| 0.711986 | 3 | 0.2% | |
| 1.627397 | 3 | 0.2% | |
| 1.808219 | 3 | 0.2% | |
| 0.942466 | 3 | 0.2% | |
| 0.739726 | 3 | 0.2% | |
| 0.172603 | 3 | 0.2% | |
| 1.587329 | 2 | 0.2% | |
| Other values (1058) | 1109 | 91.6% | |
| (Missing) | 63 | 5.2% |
| Value | Count | Frequency (%) | |
| 0 | 13 | 1.1% | |
| 0.006164 | 1 | 0.1% | |
| 0.007534 | 1 | 0.1% | |
| 0.010728 | 1 | 0.1% | |
| 0.013038 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 7.247917 | 1 | 0.1% | |
| 7.091781 | 1 | 0.1% | |
| 6.963194 | 1 | 0.1% | |
| 6.664931 | 1 | 0.1% | |
| 6.422569 | 1 | 0.1% |
| Distinct count | 319 |
|---|---|
| Unique (%) | 26.3% |
| Missing | 63 |
| Missing (%) | 5.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 109.7979094076655 |
|---|---|
| Minimum | -91.0 |
| Maximum | 514.0 |
| Zeros | 2 |
| Zeros (%) | 0.2% |
| Memory size | 9.6 KiB |
Quantile statistics
| Minimum | -91 |
|---|---|
| 5-th percentile | -9 |
| Q1 | 38.75 |
| median | 107 |
| Q3 | 164 |
| 95-th percentile | 265 |
| Maximum | 514 |
| Range | 605 |
| Interquartile range (IQR) | 125.25 |
Descriptive statistics
| Standard deviation | 84.36818423 |
|---|---|
| Coefficient of variation (CV) | 0.7683951788 |
| Kurtosis | 0.5968198344 |
| Mean | 109.7979094 |
| Median Absolute Deviation (MAD) | 68.12084036 |
| Skewness | 0.6661242844 |
| Sum | 126048 |
| Variance | 7117.99051 |
| Value | Count | Frequency (%) | |
| -11 | 12 | 1.0% | |
| 146 | 11 | 0.9% | |
| 107 | 11 | 0.9% | |
| 36 | 11 | 0.9% | |
| 184 | 10 | 0.8% | |
| 160 | 10 | 0.8% | |
| 109 | 9 | 0.7% | |
| 120 | 9 | 0.7% | |
| 150 | 9 | 0.7% | |
| 105 | 9 | 0.7% | |
| Other values (308) | 1047 | 86.5% | |
| (Missing) | 63 | 5.2% |
| Value | Count | Frequency (%) | |
| -91 | 1 | 0.1% | |
| -37 | 1 | 0.1% | |
| -32 | 1 | 0.1% | |
| -28 | 2 | 0.2% | |
| -27 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 514 | 1 | 0.1% | |
| 433 | 1 | 0.1% | |
| 409 | 1 | 0.1% | |
| 407 | 1 | 0.1% | |
| 389 | 1 | 0.1% |
| Distinct count | 26 |
|---|---|
| Unique (%) | 2.1% |
| Missing | 63 |
| Missing (%) | 5.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.07202989547038327 |
|---|---|
| Minimum | 0.0 |
| Maximum | 9.5 |
| Zeros | 1122 |
| Zeros (%) | 92.7% |
| Memory size | 9.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 9.5 |
| Range | 9.5 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.5669294451 |
|---|---|
| Coefficient of variation (CV) | 7.870752018 |
| Kurtosis | 123.3646554 |
| Mean | 0.07202989547 |
| Median Absolute Deviation (MAD) | 0.1407971127 |
| Skewness | 10.22630023 |
| Sum | 82.69032 |
| Variance | 0.3214089957 |
| Value | Count | Frequency (%) | |
| 0 | 1122 | 92.7% | |
| 1.625 | 2 | 0.2% | |
| 2.75 | 2 | 0.2% | |
| 0.9375 | 1 | 0.1% | |
| 4.375 | 1 | 0.1% | |
| 9.5 | 1 | 0.1% | |
| 7.25 | 1 | 0.1% | |
| 2.5 | 1 | 0.1% | |
| 3.5625 | 1 | 0.1% | |
| 2.625 | 1 | 0.1% | |
| Other values (15) | 15 | 1.2% | |
| (Missing) | 63 | 5.2% |
| Value | Count | Frequency (%) | |
| 0 | 1122 | 92.7% | |
| 0.9375 | 1 | 0.1% | |
| 0.987 | 1 | 0.1% | |
| 1.1995 | 1 | 0.1% | |
| 1.25 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 9.5 | 1 | 0.1% | |
| 7.25 | 1 | 0.1% | |
| 6 | 1 | 0.1% | |
| 5.75 | 1 | 0.1% | |
| 5.375 | 1 | 0.1% |
Composite_Rating
Categorical
| Distinct count | 12 |
|---|---|
| Unique (%) | 1.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 9.6 KiB |
| BBB1 | |
|---|---|
| A3 | |
| AAA | |
| BBB2 | |
| A2 | |
| Other values (7) |
| Value | Count | Frequency (%) | |
| BBB1 | 245 | 20.2% | |
| A3 | 171 | 14.1% | |
| AAA | 158 | 13.0% | |
| BBB2 | 148 | 12.2% | |
| A2 | 123 | 10.2% | |
| AA3 | 107 | 8.8% | |
| A1 | 98 | 8.1% | |
| BBB3 | 80 | 6.6% | |
| AA2 | 57 | 4.7% | |
| AA1 | 22 | 1.8% | |
| Other values (2) | 2 | 0.2% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 4 |
|---|---|
| Mean length | 3.06688687 |
| Min length | 2 |
Country
Categorical
| Distinct count | 36 |
|---|---|
| Unique (%) | 3.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 9.6 KiB |
| GB | |
|---|---|
| US | 117 |
| DE | 92 |
| FR | 61 |
| XB | 54 |
| Other values (31) |
| Value | Count | Frequency (%) | |
| GB | 678 | 56.0% | |
| US | 117 | 9.7% | |
| DE | 92 | 7.6% | |
| FR | 61 | 5.0% | |
| XB | 54 | 4.5% | |
| NL | 35 | 2.9% | |
| AU | 27 | 2.2% | |
| SE | 21 | 1.7% | |
| CA | 18 | 1.5% | |
| IT | 13 | 1.1% | |
| Other values (26) | 95 | 7.8% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | True |
| Contains non-words | True |
Length
| Max length | 11 |
|---|---|
| Mean length | 2.015689513 |
| Min length | 2 |
Coupon
Real number (ℝ≥0)
| Distinct count | 323 |
|---|---|
| Unique (%) | 26.7% |
| Missing | 1 |
| Missing (%) | 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.241143696446281 |
|---|---|
| Minimum | 0.0 |
| Maximum | 12.0 |
| Zeros | 10 |
| Zeros (%) | 0.8% |
| Memory size | 9.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.875 |
| Q1 | 2.625 |
| median | 4.5 |
| Q3 | 5.75 |
| 95-th percentile | 7.25 |
| Maximum | 12 |
| Range | 12 |
| Interquartile range (IQR) | 3.125 |
Descriptive statistics
| Standard deviation | 2.059010337 |
|---|---|
| Coefficient of variation (CV) | 0.4854846909 |
| Kurtosis | -0.430974704 |
| Mean | 4.241143696 |
| Median Absolute Deviation (MAD) | 1.712678789 |
| Skewness | -0.008399202691 |
| Sum | 5131.783873 |
| Variance | 4.239523567 |
| Value | Count | Frequency (%) | |
| 5.75 | 35 | 2.9% | |
| 5.25 | 29 | 2.4% | |
| 5.5 | 29 | 2.4% | |
| 1.125 | 26 | 2.1% | |
| 5.375 | 24 | 2.0% | |
| 1 | 24 | 2.0% | |
| 4.875 | 23 | 1.9% | |
| 6.125 | 23 | 1.9% | |
| 5.125 | 23 | 1.9% | |
| 5 | 22 | 1.8% | |
| Other values (312) | 952 | 78.6% |
| Value | Count | Frequency (%) | |
| 0 | 10 | 0.8% | |
| 1e-06 | 1 | 0.1% | |
| 0.01 | 1 | 0.1% | |
| 0.07 | 1 | 0.1% | |
| 0.1 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 12 | 1 | 0.1% | |
| 10.231 | 1 | 0.1% | |
| 10 | 2 | 0.2% | |
| 9.75 | 1 | 0.1% | |
| 9.625 | 2 | 0.2% |
| Distinct count | 1 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 9.6 KiB |
| GBP |
|---|
| Value | Count | Frequency (%) | |
| GBP | 1211 | 100.0% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 3 |
|---|---|
| Mean length | 3 |
| Min length | 3 |
| Distinct count | 1211 |
|---|---|
| Unique (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 9.6 KiB |
| 'AR739783' | 1 |
|---|---|
| 'AS401560' | 1 |
| BRT9PTU22 | 1 |
| 'JV790367' | 1 |
| 'AT044568' | 1 |
| Other values (1206) |
| Value | Count | Frequency (%) | |
| 'AR739783' | 1 | 0.1% | |
| 'AS401560' | 1 | 0.1% | |
| BRT9PTU22 | 1 | 0.1% | |
| 'JV790367' | 1 | 0.1% | |
| 'AT044568' | 1 | 0.1% | |
| 'ED259812' | 1 | 0.1% | |
| 'AM980936' | 1 | 0.1% | |
| 'UV923483' | 1 | 0.1% | |
| 'EI322173' | 1 | 0.1% | |
| 'QZ498649' | 1 | 0.1% | |
| Other values (1201) | 1201 | 99.2% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 10 |
|---|---|
| Mean length | 9.947976879 |
| Min length | 9 |
| Distinct count | 562 |
|---|---|
| Unique (%) | 46.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 9.6 KiB |
| European Investment Bank | 22 |
|---|---|
| Kreditanstalt Fur Wiederaufbau | 19 |
| Lloyds Bank plc | 11 |
| Thames Water Utilities Cayman Finance Limited | 11 |
| Heathrow Funding Limited | 10 |
| Other values (557) |
| Value | Count | Frequency (%) | |
| European Investment Bank | 22 | 1.8% | |
| Kreditanstalt Fur Wiederaufbau | 19 | 1.6% | |
| Lloyds Bank plc | 11 | 0.9% | |
| Thames Water Utilities Cayman Finance Limited | 11 | 0.9% | |
| Heathrow Funding Limited | 10 | 0.8% | |
| Electricite de France SA | 10 | 0.8% | |
| International Bank for Reconstruction and Development | 10 | 0.8% | |
| Cooperatieve Rabobank U.A. | 10 | 0.8% | |
| B.A.T. International Finance p.l.c. | 9 | 0.7% | |
| Transport For London | 9 | 0.7% | |
| Other values (552) | 1090 | 90.0% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | True |
| Contains non-words | True |
Length
| Max length | 61 |
|---|---|
| Mean length | 25.01238646 |
| Min length | 3 |
| Distinct count | 1096 |
|---|---|
| Unique (%) | 90.5% |
| Missing | 63 |
| Missing (%) | 5.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.397273519163763 |
|---|---|
| Minimum | 0.0 |
| Maximum | 34.792 |
| Zeros | 1 |
| Zeros (%) | 0.1% |
| Memory size | 9.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1.44705 |
| Q1 | 3.4915 |
| median | 6.1265 |
| Q3 | 10.1535 |
| 95-th percentile | 17.84225 |
| Maximum | 34.792 |
| Range | 34.792 |
| Interquartile range (IQR) | 6.662 |
Descriptive statistics
| Standard deviation | 5.146055476 |
|---|---|
| Coefficient of variation (CV) | 0.6956692169 |
| Kurtosis | 1.741983247 |
| Mean | 7.397273519 |
| Median Absolute Deviation (MAD) | 4.058087588 |
| Skewness | 1.211896612 |
| Sum | 8492.07 |
| Variance | 26.48188697 |
| Value | Count | Frequency (%) | |
| 9.294 | 3 | 0.2% | |
| 2.692 | 3 | 0.2% | |
| 3.164 | 2 | 0.2% | |
| 5.093 | 2 | 0.2% | |
| 3.273 | 2 | 0.2% | |
| 1.325 | 2 | 0.2% | |
| 6.065 | 2 | 0.2% | |
| 4.006 | 2 | 0.2% | |
| 12.65 | 2 | 0.2% | |
| 1.487 | 2 | 0.2% | |
| Other values (1085) | 1126 | 93.0% | |
| (Missing) | 63 | 5.2% |
| Value | Count | Frequency (%) | |
| 0 | 1 | 0.1% | |
| 0.449 | 1 | 0.1% | |
| 0.713 | 1 | 0.1% | |
| 0.945 | 1 | 0.1% | |
| 0.958 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 34.792 | 1 | 0.1% | |
| 34.564 | 1 | 0.1% | |
| 31.647 | 1 | 0.1% | |
| 24.786 | 1 | 0.1% | |
| 24.576 | 1 | 0.1% |
| Distinct count | 1150 |
|---|---|
| Unique (%) | 95.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.855655656482247 |
|---|---|
| Minimum | 0.0 |
| Maximum | 35.21 |
| Zeros | 2 |
| Zeros (%) | 0.2% |
| Memory size | 9.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1.435 |
| Q1 | 3.574 |
| median | 6.45 |
| Q3 | 10.955 |
| 95-th percentile | 18.921 |
| Maximum | 35.21 |
| Range | 35.21 |
| Interquartile range (IQR) | 7.381 |
Descriptive statistics
| Standard deviation | 5.508674709 |
|---|---|
| Coefficient of variation (CV) | 0.701236784 |
| Kurtosis | 1.230656394 |
| Mean | 7.855655656 |
| Median Absolute Deviation (MAD) | 4.384811994 |
| Skewness | 1.124252703 |
| Sum | 9513.199 |
| Variance | 30.34549704 |
| Value | Count | Frequency (%) | |
| 4.25 | 3 | 0.2% | |
| 4.237 | 3 | 0.2% | |
| 1.335 | 3 | 0.2% | |
| 1.863 | 2 | 0.2% | |
| 3.318 | 2 | 0.2% | |
| 2.432 | 2 | 0.2% | |
| 2.336 | 2 | 0.2% | |
| 3.287 | 2 | 0.2% | |
| 2.489 | 2 | 0.2% | |
| 2.509 | 2 | 0.2% | |
| Other values (1140) | 1188 | 98.1% |
| Value | Count | Frequency (%) | |
| 0 | 2 | 0.2% | |
| 0.057 | 1 | 0.1% | |
| 0.454 | 1 | 0.1% | |
| 0.718 | 1 | 0.1% | |
| 0.946 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 35.21 | 1 | 0.1% | |
| 34.981 | 1 | 0.1% | |
| 32.23 | 1 | 0.1% | |
| 27.6 | 1 | 0.1% | |
| 27.28 | 1 | 0.1% |
| Distinct count | 960 |
|---|---|
| Unique (%) | 79.3% |
| Missing | 63 |
| Missing (%) | 5.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.437878048780488 |
|---|---|
| Minimum | 0.0 |
| Maximum | 6.506 |
| Zeros | 1 |
| Zeros (%) | 0.1% |
| Memory size | 9.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1.1117 |
| Q1 | 1.668 |
| median | 2.504 |
| Q3 | 3.093 |
| 95-th percentile | 3.864 |
| Maximum | 6.506 |
| Range | 6.506 |
| Interquartile range (IQR) | 1.425 |
Descriptive statistics
| Standard deviation | 0.8884368908 |
|---|---|
| Coefficient of variation (CV) | 0.3644304075 |
| Kurtosis | -0.01818541367 |
| Mean | 2.437878049 |
| Median Absolute Deviation (MAD) | 0.7368084049 |
| Skewness | 0.3164589254 |
| Sum | 2798.684 |
| Variance | 0.7893201089 |
| Value | Count | Frequency (%) | |
| 2.98 | 3 | 0.2% | |
| 3.288 | 3 | 0.2% | |
| 1.739 | 3 | 0.2% | |
| 2.796 | 3 | 0.2% | |
| 3.046 | 3 | 0.2% | |
| 3.196 | 3 | 0.2% | |
| 2.704 | 3 | 0.2% | |
| 1.947 | 3 | 0.2% | |
| 1.668 | 3 | 0.2% | |
| 2.801 | 3 | 0.2% | |
| Other values (949) | 1118 | 92.3% | |
| (Missing) | 63 | 5.2% |
| Value | Count | Frequency (%) | |
| 0 | 1 | 0.1% | |
| 0.502 | 1 | 0.1% | |
| 0.658 | 1 | 0.1% | |
| 0.726 | 1 | 0.1% | |
| 0.738 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 6.506 | 1 | 0.1% | |
| 5.399 | 1 | 0.1% | |
| 5.37 | 1 | 0.1% | |
| 5.208 | 1 | 0.1% | |
| 5.161 | 1 | 0.1% |
| Distinct count | 618 |
|---|---|
| Unique (%) | 51.0% |
| Missing | 63 |
| Missing (%) | 5.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.23136062717770037 |
|---|---|
| Minimum | -1.9669999999999999 |
| Maximum | 3.6460000000000004 |
| Zeros | 4 |
| Zeros (%) | 0.3% |
| Memory size | 9.6 KiB |
Quantile statistics
| Minimum | -1.967 |
|---|---|
| 5-th percentile | -0.056 |
| Q1 | 0.029 |
| median | 0.1285 |
| Q3 | 0.34975 |
| 95-th percentile | 0.8706 |
| Maximum | 3.646 |
| Range | 5.613 |
| Interquartile range (IQR) | 0.32075 |
Descriptive statistics
| Standard deviation | 0.3492697859 |
|---|---|
| Coefficient of variation (CV) | 1.509633641 |
| Kurtosis | 12.9518078 |
| Mean | 0.2313606272 |
| Median Absolute Deviation (MAD) | 0.2400111875 |
| Skewness | 1.585109819 |
| Sum | 265.602 |
| Variance | 0.1219893833 |
| Value | Count | Frequency (%) | |
| -0.016 | 10 | 0.8% | |
| 0.054 | 9 | 0.7% | |
| 0.072 | 9 | 0.7% | |
| 0.045 | 8 | 0.7% | |
| 0.075 | 8 | 0.7% | |
| 0.076 | 8 | 0.7% | |
| 0.01 | 7 | 0.6% | |
| -0.001 | 7 | 0.6% | |
| 0.03 | 7 | 0.6% | |
| -0.015 | 6 | 0.5% | |
| Other values (607) | 1069 | 88.3% | |
| (Missing) | 63 | 5.2% |
| Value | Count | Frequency (%) | |
| -1.967 | 1 | 0.1% | |
| -1.669 | 1 | 0.1% | |
| -1.186 | 1 | 0.1% | |
| -1.128 | 1 | 0.1% | |
| -0.926 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 3.646 | 1 | 0.1% | |
| 2.231 | 1 | 0.1% | |
| 1.965 | 1 | 0.1% | |
| 1.933 | 1 | 0.1% | |
| 1.704 | 1 | 0.1% |
| Distinct count | 242 |
|---|---|
| Unique (%) | 20.0% |
| Missing | 63 |
| Missing (%) | 5.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 441.27526829268294 |
|---|---|
| Minimum | 100.0 |
| Maximum | 4800.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 9.6 KiB |
Quantile statistics
| Minimum | 100 |
|---|---|
| 5-th percentile | 150 |
| Q1 | 250 |
| median | 350 |
| Q3 | 500 |
| 95-th percentile | 1000 |
| Maximum | 4800 |
| Range | 4700 |
| Interquartile range (IQR) | 250 |
Descriptive statistics
| Standard deviation | 327.8857442 |
|---|---|
| Coefficient of variation (CV) | 0.7430412892 |
| Kurtosis | 34.6182791 |
| Mean | 441.2752683 |
| Median Absolute Deviation (MAD) | 212.0823427 |
| Skewness | 4.08779044 |
| Sum | 506584.008 |
| Variance | 107509.0613 |
| Value | Count | Frequency (%) | |
| 250 | 148 | 12.2% | |
| 300 | 123 | 10.2% | |
| 500 | 102 | 8.4% | |
| 400 | 82 | 6.8% | |
| 350 | 75 | 6.2% | |
| 200 | 53 | 4.4% | |
| 750 | 36 | 3.0% | |
| 150 | 31 | 2.6% | |
| 1000 | 30 | 2.5% | |
| 600 | 29 | 2.4% | |
| Other values (231) | 439 | 36.3% | |
| (Missing) | 63 | 5.2% |
| Value | Count | Frequency (%) | |
| 100 | 17 | 1.4% | |
| 100.6 | 1 | 0.1% | |
| 102 | 1 | 0.1% | |
| 105 | 1 | 0.1% | |
| 105.6 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 4800 | 1 | 0.1% | |
| 3035 | 1 | 0.1% | |
| 2537.1 | 1 | 0.1% | |
| 2274.3 | 1 | 0.1% | |
| 2065 | 1 | 0.1% |
| Distinct count | 43 |
|---|---|
| Unique (%) | 3.6% |
| Missing | 1150 |
| Missing (%) | 95.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 75.39344262295081 |
|---|---|
| Minimum | 6.0 |
| Maximum | 222.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 9.6 KiB |
Quantile statistics
| Minimum | 6 |
|---|---|
| 5-th percentile | 33 |
| Q1 | 42 |
| median | 61 |
| Q3 | 93 |
| 95-th percentile | 167 |
| Maximum | 222 |
| Range | 216 |
| Interquartile range (IQR) | 51 |
Descriptive statistics
| Standard deviation | 43.82513688 |
|---|---|
| Coefficient of variation (CV) | 0.5812857904 |
| Kurtosis | 1.557430152 |
| Mean | 75.39344262 |
| Median Absolute Deviation (MAD) | 32.94221983 |
| Skewness | 1.364242744 |
| Sum | 4599 |
| Variance | 1920.642623 |
| Value | Count | Frequency (%) | |
| 61 | 4 | 0.3% | |
| 40 | 4 | 0.3% | |
| 74 | 3 | 0.2% | |
| 79 | 2 | 0.2% | |
| 35 | 2 | 0.2% | |
| 42 | 2 | 0.2% | |
| 53 | 2 | 0.2% | |
| 36 | 2 | 0.2% | |
| 110 | 2 | 0.2% | |
| 55 | 2 | 0.2% | |
| Other values (32) | 36 | 3.0% | |
| (Missing) | 1150 | 95.0% |
| Value | Count | Frequency (%) | |
| 6 | 1 | 0.1% | |
| 31 | 1 | 0.1% | |
| 32 | 1 | 0.1% | |
| 33 | 1 | 0.1% | |
| 35 | 2 | 0.2% |
| Value | Count | Frequency (%) | |
| 222 | 1 | 0.1% | |
| 172 | 1 | 0.1% | |
| 169 | 1 | 0.1% | |
| 167 | 1 | 0.1% | |
| 165 | 1 | 0.1% |
| Distinct count | 1159 |
|---|---|
| Unique (%) | 95.7% |
| Missing | 51 |
| Missing (%) | 4.2% |
| Memory size | 9.6 KiB |
| XS0186855150 | 2 |
|---|---|
| XS0109320688 | 2 |
| XS1645518736 | 1 |
| XS1548413696 | 1 |
| BE0934986036 | 1 |
| Other values (1153) |
| Value | Count | Frequency (%) | |
| XS0186855150 | 2 | 0.2% | |
| XS0109320688 | 2 | 0.2% | |
| XS1645518736 | 1 | 0.1% | |
| XS1548413696 | 1 | 0.1% | |
| BE0934986036 | 1 | 0.1% | |
| XS1768715556 | 1 | 0.1% | |
| XS0702029132 | 1 | 0.1% | |
| XS1596735701 | 1 | 0.1% | |
| XS0633547087 | 1 | 0.1% | |
| XS0903532090 | 1 | 0.1% | |
| Other values (1148) | 1148 | 94.8% | |
| (Missing) | 51 | 4.2% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 12 |
|---|---|
| Mean length | 11.6209744 |
| Min length | 3 |
| Distinct count | 983 |
|---|---|
| Unique (%) | 81.2% |
| Missing | 1 |
| Missing (%) | 0.1% |
| Memory size | 9.6 KiB |
| 12/07/2028 | 12 |
|---|---|
| 12/15/2023 | 10 |
| 06/07/2032 | 9 |
| 12/15/2022 | 8 |
| 12/15/2020 | 8 |
| Other values (977) |
| Value | Count | Frequency (%) | |
| 12/07/2028 | 12 | 1.0% | |
| 12/15/2023 | 10 | 0.8% | |
| 06/07/2032 | 9 | 0.7% | |
| 12/15/2022 | 8 | 0.7% | |
| 12/15/2020 | 8 | 0.7% | |
| 06/07/2021 | 8 | 0.7% | |
| 6/30/2022 | 6 | 0.5% | |
| 12/10/2031 | 6 | 0.5% | |
| 09/07/2021 | 5 | 0.4% | |
| 12/15/2021 | 5 | 0.4% | |
| Other values (972) | 1133 | 93.6% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 10 |
|---|---|
| Mean length | 9.58629232 |
| Min length | 3 |
| Distinct count | 277 |
|---|---|
| Unique (%) | 22.9% |
| Missing | 63 |
| Missing (%) | 5.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 121.73780487804878 |
|---|---|
| Minimum | -125.0 |
| Maximum | 553.0 |
| Zeros | 2 |
| Zeros (%) | 0.2% |
| Memory size | 9.6 KiB |
Quantile statistics
| Minimum | -125 |
|---|---|
| 5-th percentile | 24 |
| Q1 | 67 |
| median | 119 |
| Q3 | 158.25 |
| 95-th percentile | 250.65 |
| Maximum | 553 |
| Range | 678 |
| Interquartile range (IQR) | 91.25 |
Descriptive statistics
| Standard deviation | 71.70101683 |
|---|---|
| Coefficient of variation (CV) | 0.5889790514 |
| Kurtosis | 2.353966654 |
| Mean | 121.7378049 |
| Median Absolute Deviation (MAD) | 55.15595521 |
| Skewness | 1.00600991 |
| Sum | 139755 |
| Variance | 5141.035815 |
| Value | Count | Frequency (%) | |
| 26 | 13 | 1.1% | |
| 133 | 12 | 1.0% | |
| 67 | 12 | 1.0% | |
| 65 | 11 | 0.9% | |
| 134 | 11 | 0.9% | |
| 150 | 11 | 0.9% | |
| 135 | 11 | 0.9% | |
| 34 | 11 | 0.9% | |
| 62 | 10 | 0.8% | |
| 140 | 10 | 0.8% | |
| Other values (266) | 1036 | 85.5% | |
| (Missing) | 63 | 5.2% |
| Value | Count | Frequency (%) | |
| -125 | 1 | 0.1% | |
| -3 | 1 | 0.1% | |
| -2 | 1 | 0.1% | |
| 0 | 2 | 0.2% | |
| 1 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 553 | 1 | 0.1% | |
| 449 | 1 | 0.1% | |
| 411 | 1 | 0.1% | |
| 401 | 1 | 0.1% | |
| 398 | 1 | 0.1% |
| Distinct count | 289 |
|---|---|
| Unique (%) | 23.9% |
| Missing | 63 |
| Missing (%) | 5.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 100.64634146341463 |
|---|---|
| Minimum | -126.0 |
| Maximum | 517.0 |
| Zeros | 2 |
| Zeros (%) | 0.2% |
| Memory size | 9.6 KiB |
Quantile statistics
| Minimum | -126 |
|---|---|
| 5-th percentile | -10 |
| Q1 | 37 |
| median | 99.5 |
| Q3 | 150 |
| 95-th percentile | 232.25 |
| Maximum | 517 |
| Range | 643 |
| Interquartile range (IQR) | 113 |
Descriptive statistics
| Standard deviation | 77.17947705 |
|---|---|
| Coefficient of variation (CV) | 0.7668383761 |
| Kurtosis | 1.157289354 |
| Mean | 100.6463415 |
| Median Absolute Deviation (MAD) | 61.80353956 |
| Skewness | 0.7237675136 |
| Sum | 115542 |
| Variance | 5956.671678 |
| Value | Count | Frequency (%) | |
| 30 | 15 | 1.2% | |
| 98 | 12 | 1.0% | |
| 38 | 12 | 1.0% | |
| 160 | 11 | 0.9% | |
| 118 | 11 | 0.9% | |
| 124 | 10 | 0.8% | |
| 150 | 10 | 0.8% | |
| 105 | 10 | 0.8% | |
| 159 | 10 | 0.8% | |
| -12 | 10 | 0.8% | |
| Other values (278) | 1037 | 85.6% | |
| (Missing) | 63 | 5.2% |
| Value | Count | Frequency (%) | |
| -126 | 1 | 0.1% | |
| -38 | 1 | 0.1% | |
| -33 | 1 | 0.1% | |
| -29 | 1 | 0.1% | |
| -28 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 517 | 1 | 0.1% | |
| 418 | 1 | 0.1% | |
| 375 | 1 | 0.1% | |
| 373 | 1 | 0.1% | |
| 372 | 1 | 0.1% |
| Distinct count | 1204 |
|---|---|
| Unique (%) | 99.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 113.21259749793558 |
|---|---|
| Minimum | 69.61740999999999 |
| Maximum | 188.2966 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 9.6 KiB |
Quantile statistics
| Minimum | 69.61741 |
|---|---|
| 5-th percentile | 96.839345 |
| Q1 | 100.28565 |
| median | 109.6201 |
| Q3 | 122.58495 |
| 95-th percentile | 142.22375 |
| Maximum | 188.2966 |
| Range | 118.67919 |
| Interquartile range (IQR) | 22.2993 |
Descriptive statistics
| Standard deviation | 15.72437169 |
|---|---|
| Coefficient of variation (CV) | 0.1388924204 |
| Kurtosis | 0.9844858831 |
| Mean | 113.2125975 |
| Median Absolute Deviation (MAD) | 12.62937711 |
| Skewness | 0.9181009294 |
| Sum | 137100.4556 |
| Variance | 247.2558649 |
| Value | Count | Frequency (%) | |
| 99.06 | 2 | 0.2% | |
| 120.4938 | 2 | 0.2% | |
| 102 | 2 | 0.2% | |
| 117.25 | 2 | 0.2% | |
| 81.42385 | 2 | 0.2% | |
| 108.43 | 2 | 0.2% | |
| 112.735 | 2 | 0.2% | |
| 105.8336 | 1 | 0.1% | |
| 113.9629 | 1 | 0.1% | |
| 116.1957 | 1 | 0.1% | |
| Other values (1194) | 1194 | 98.6% |
| Value | Count | Frequency (%) | |
| 69.61741 | 1 | 0.1% | |
| 70.28412 | 1 | 0.1% | |
| 71.20482 | 1 | 0.1% | |
| 72.69 | 1 | 0.1% | |
| 75.35 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 188.2966 | 1 | 0.1% | |
| 176.41 | 1 | 0.1% | |
| 174.2116 | 1 | 0.1% | |
| 171.5 | 1 | 0.1% | |
| 170.0197 | 1 | 0.1% |
| Distinct count | 1087 |
|---|---|
| Unique (%) | 89.8% |
| Missing | 64 |
| Missing (%) | 5.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.08718393199651263 |
|---|---|
| Minimum | 0.016069999999999997 |
| Maximum | 0.8322299999999999 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 9.6 KiB |
Quantile statistics
| Minimum | 0.01607 |
|---|---|
| 5-th percentile | 0.029036 |
| Q1 | 0.048415 |
| median | 0.06754 |
| Q3 | 0.10266 |
| 95-th percentile | 0.212269 |
| Maximum | 0.83223 |
| Range | 0.81616 |
| Interquartile range (IQR) | 0.054245 |
Descriptive statistics
| Standard deviation | 0.06792751455 |
|---|---|
| Coefficient of variation (CV) | 0.7791288257 |
| Kurtosis | 26.51961732 |
| Mean | 0.087183932 |
| Median Absolute Deviation (MAD) | 0.04344303301 |
| Skewness | 3.844648695 |
| Sum | 99.99997 |
| Variance | 0.004614147233 |
| Value | Count | Frequency (%) | |
| 0.04296 | 3 | 0.2% | |
| 0.05216 | 3 | 0.2% | |
| 0.05356 | 3 | 0.2% | |
| 0.04838 | 2 | 0.2% | |
| 0.05147 | 2 | 0.2% | |
| 0.05112 | 2 | 0.2% | |
| 0.0756 | 2 | 0.2% | |
| 0.06754 | 2 | 0.2% | |
| 0.07078 | 2 | 0.2% | |
| 0.06329 | 2 | 0.2% | |
| Other values (1076) | 1124 | 92.8% | |
| (Missing) | 64 | 5.3% |
| Value | Count | Frequency (%) | |
| 0.01607 | 1 | 0.1% | |
| 0.01698 | 1 | 0.1% | |
| 0.01699 | 1 | 0.1% | |
| 0.017 | 1 | 0.1% | |
| 0.01703 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 0.83223 | 1 | 0.1% | |
| 0.75273 | 1 | 0.1% | |
| 0.56153 | 1 | 0.1% | |
| 0.51845 | 1 | 0.1% | |
| 0.49312 | 1 | 0.1% |
| Distinct count | 948 |
|---|---|
| Unique (%) | 78.3% |
| Missing | 64 |
| Missing (%) | 5.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.713801220575414 |
|---|---|
| Minimum | 0.0 |
| Maximum | 9.342 |
| Zeros | 11 |
| Zeros (%) | 0.9% |
| Memory size | 9.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.0873 |
| Q1 | 0.537 |
| median | 1.266 |
| Q3 | 2.613 |
| 95-th percentile | 4.7651 |
| Maximum | 9.342 |
| Range | 9.342 |
| Interquartile range (IQR) | 2.076 |
Descriptive statistics
| Standard deviation | 1.519272467 |
|---|---|
| Coefficient of variation (CV) | 0.886492814 |
| Kurtosis | 0.9507558538 |
| Mean | 1.713801221 |
| Median Absolute Deviation (MAD) | 1.223431989 |
| Skewness | 1.154802791 |
| Sum | 1965.73 |
| Variance | 2.308188828 |
| Value | Count | Frequency (%) | |
| 0 | 11 | 0.9% | |
| 0.81 | 5 | 0.4% | |
| 0.129 | 4 | 0.3% | |
| 0.848 | 4 | 0.3% | |
| 1.516 | 4 | 0.3% | |
| 0.863 | 4 | 0.3% | |
| 0.163 | 4 | 0.3% | |
| 0.684 | 4 | 0.3% | |
| 1.359 | 3 | 0.2% | |
| 0.048 | 3 | 0.2% | |
| Other values (937) | 1101 | 90.9% | |
| (Missing) | 64 | 5.3% |
| Value | Count | Frequency (%) | |
| 0 | 11 | 0.9% | |
| 0.007 | 1 | 0.1% | |
| 0.008 | 1 | 0.1% | |
| 0.009 | 1 | 0.1% | |
| 0.01 | 2 | 0.2% |
| Value | Count | Frequency (%) | |
| 9.342 | 1 | 0.1% | |
| 7.19 | 1 | 0.1% | |
| 7.026 | 1 | 0.1% | |
| 6.901 | 1 | 0.1% | |
| 6.732 | 1 | 0.1% |
| Distinct count | 311 |
|---|---|
| Unique (%) | 25.7% |
| Missing | 64 |
| Missing (%) | 5.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 112.47079337401918 |
|---|---|
| Minimum | -83.0 |
| Maximum | 510.0 |
| Zeros | 3 |
| Zeros (%) | 0.2% |
| Memory size | 9.6 KiB |
Quantile statistics
| Minimum | -83 |
|---|---|
| 5-th percentile | -8.7 |
| Q1 | 42 |
| median | 110 |
| Q3 | 167.5 |
| 95-th percentile | 265 |
| Maximum | 510 |
| Range | 593 |
| Interquartile range (IQR) | 125.5 |
Descriptive statistics
| Standard deviation | 84.0963555 |
|---|---|
| Coefficient of variation (CV) | 0.7477172782 |
| Kurtosis | 0.3461846759 |
| Mean | 112.4707934 |
| Median Absolute Deviation (MAD) | 68.34422689 |
| Skewness | 0.5877098473 |
| Sum | 129004 |
| Variance | 7072.197008 |
| Value | Count | Frequency (%) | |
| 44 | 12 | 1.0% | |
| -14 | 11 | 0.9% | |
| -12 | 11 | 0.9% | |
| 131 | 10 | 0.8% | |
| 22 | 10 | 0.8% | |
| 124 | 10 | 0.8% | |
| 42 | 10 | 0.8% | |
| 163 | 9 | 0.7% | |
| 43 | 9 | 0.7% | |
| 36 | 8 | 0.7% | |
| Other values (300) | 1047 | 86.5% | |
| (Missing) | 64 | 5.3% |
| Value | Count | Frequency (%) | |
| -83 | 1 | 0.1% | |
| -36 | 1 | 0.1% | |
| -32 | 1 | 0.1% | |
| -27 | 2 | 0.2% | |
| -26 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 510 | 1 | 0.1% | |
| 410 | 1 | 0.1% | |
| 407 | 1 | 0.1% | |
| 380 | 2 | 0.2% | |
| 367 | 1 | 0.1% |
| Distinct count | 1090 |
|---|---|
| Unique (%) | 90.0% |
| Missing | 64 |
| Missing (%) | 5.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.411163034001743 |
|---|---|
| Minimum | 0.474 |
| Maximum | 34.352 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 9.6 KiB |
Quantile statistics
| Minimum | 0.474 |
|---|---|
| 5-th percentile | 1.487 |
| Q1 | 3.516 |
| median | 6.138 |
| Q3 | 10.1665 |
| 95-th percentile | 17.7374 |
| Maximum | 34.352 |
| Range | 33.878 |
| Interquartile range (IQR) | 6.6505 |
Descriptive statistics
| Standard deviation | 5.118495274 |
|---|---|
| Coefficient of variation (CV) | 0.6906466975 |
| Kurtosis | 1.679508337 |
| Mean | 7.411163034 |
| Median Absolute Deviation (MAD) | 4.041339399 |
| Skewness | 1.20078965 |
| Sum | 8500.604 |
| Variance | 26.19899387 |
| Value | Count | Frequency (%) | |
| 6.086 | 3 | 0.2% | |
| 3.723 | 3 | 0.2% | |
| 2.441 | 3 | 0.2% | |
| 10.256 | 2 | 0.2% | |
| 6.033 | 2 | 0.2% | |
| 2.715 | 2 | 0.2% | |
| 3.256 | 2 | 0.2% | |
| 1.352 | 2 | 0.2% | |
| 2.319 | 2 | 0.2% | |
| 4.577 | 2 | 0.2% | |
| Other values (1079) | 1124 | 92.8% | |
| (Missing) | 64 | 5.3% |
| Value | Count | Frequency (%) | |
| 0.474 | 1 | 0.1% | |
| 0.738 | 1 | 0.1% | |
| 0.958 | 1 | 0.1% | |
| 0.969 | 1 | 0.1% | |
| 0.982 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 34.352 | 1 | 0.1% | |
| 34.193 | 1 | 0.1% | |
| 31.582 | 1 | 0.1% | |
| 24.721 | 1 | 0.1% | |
| 24.522 | 1 | 0.1% |
| Distinct count | 1092 |
|---|---|
| Unique (%) | 90.2% |
| Missing | 64 |
| Missing (%) | 5.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.497461203138624 |
|---|---|
| Minimum | 0.48200000000000004 |
| Maximum | 34.771 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 9.6 KiB |
Quantile statistics
| Minimum | 0.482 |
|---|---|
| 5-th percentile | 1.4444 |
| Q1 | 3.5375 |
| median | 6.253 |
| Q3 | 10.3365 |
| 95-th percentile | 17.9118 |
| Maximum | 34.771 |
| Range | 34.289 |
| Interquartile range (IQR) | 6.799 |
Descriptive statistics
| Standard deviation | 5.148861914 |
|---|---|
| Coefficient of variation (CV) | 0.6867473902 |
| Kurtosis | 1.346944535 |
| Mean | 7.497461203 |
| Median Absolute Deviation (MAD) | 4.09410878 |
| Skewness | 1.130583023 |
| Sum | 8599.588 |
| Variance | 26.51077901 |
| Value | Count | Frequency (%) | |
| 2.533 | 3 | 0.2% | |
| 1.887 | 3 | 0.2% | |
| 1.145 | 2 | 0.2% | |
| 1.373 | 2 | 0.2% | |
| 3.801 | 2 | 0.2% | |
| 1.47 | 2 | 0.2% | |
| 4.274 | 2 | 0.2% | |
| 4.034 | 2 | 0.2% | |
| 6.619 | 2 | 0.2% | |
| 6.556 | 2 | 0.2% | |
| Other values (1081) | 1125 | 92.9% | |
| (Missing) | 64 | 5.3% |
| Value | Count | Frequency (%) | |
| 0.482 | 1 | 0.1% | |
| 0.742 | 1 | 0.1% | |
| 0.963 | 1 | 0.1% | |
| 0.976 | 1 | 0.1% | |
| 0.98 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 34.771 | 1 | 0.1% | |
| 34.61 | 1 | 0.1% | |
| 24.895 | 1 | 0.1% | |
| 24.835 | 1 | 0.1% | |
| 24.133 | 1 | 0.1% |
| Distinct count | 946 |
|---|---|
| Unique (%) | 78.1% |
| Missing | 64 |
| Missing (%) | 5.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.4827689625108977 |
|---|---|
| Minimum | 0.623 |
| Maximum | 6.479 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 9.6 KiB |
Quantile statistics
| Minimum | 0.623 |
|---|---|
| 5-th percentile | 1.1482 |
| Q1 | 1.72 |
| median | 2.549 |
| Q3 | 3.142 |
| 95-th percentile | 3.8945 |
| Maximum | 6.479 |
| Range | 5.856 |
| Interquartile range (IQR) | 1.422 |
Descriptive statistics
| Standard deviation | 0.8865688148 |
|---|---|
| Coefficient of variation (CV) | 0.3570887296 |
| Kurtosis | -0.139632031 |
| Mean | 2.482768963 |
| Median Absolute Deviation (MAD) | 0.7388513335 |
| Skewness | 0.2860421486 |
| Sum | 2847.736 |
| Variance | 0.7860042633 |
| Value | Count | Frequency (%) | |
| 3.19 | 4 | 0.3% | |
| 2.016 | 3 | 0.2% | |
| 2.799 | 3 | 0.2% | |
| 3.078 | 3 | 0.2% | |
| 2.509 | 3 | 0.2% | |
| 2.863 | 3 | 0.2% | |
| 2.804 | 3 | 0.2% | |
| 3.324 | 3 | 0.2% | |
| 2.158 | 3 | 0.2% | |
| 1.377 | 3 | 0.2% | |
| Other values (935) | 1116 | 92.2% | |
| (Missing) | 64 | 5.3% |
| Value | Count | Frequency (%) | |
| 0.623 | 1 | 0.1% | |
| 0.684 | 1 | 0.1% | |
| 0.757 | 1 | 0.1% | |
| 0.817 | 1 | 0.1% | |
| 0.854 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 6.479 | 1 | 0.1% | |
| 5.394 | 1 | 0.1% | |
| 5.373 | 1 | 0.1% | |
| 5.263 | 1 | 0.1% | |
| 5.156 | 1 | 0.1% |
| Distinct count | 281 |
|---|---|
| Unique (%) | 23.2% |
| Missing | 64 |
| Missing (%) | 5.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 123.96774193548387 |
|---|---|
| Minimum | -115.0 |
| Maximum | 548.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 9.6 KiB |
Quantile statistics
| Minimum | -115 |
|---|---|
| 5-th percentile | 24.3 |
| Q1 | 70 |
| median | 121 |
| Q3 | 162 |
| 95-th percentile | 256.2 |
| Maximum | 548 |
| Range | 663 |
| Interquartile range (IQR) | 92 |
Descriptive statistics
| Standard deviation | 71.24253616 |
|---|---|
| Coefficient of variation (CV) | 0.574686084 |
| Kurtosis | 1.861299172 |
| Mean | 123.9677419 |
| Median Absolute Deviation (MAD) | 55.40726158 |
| Skewness | 0.889750421 |
| Sum | 142191 |
| Variance | 5075.498959 |
| Value | Count | Frequency (%) | |
| 146 | 14 | 1.2% | |
| 22 | 14 | 1.2% | |
| 140 | 13 | 1.1% | |
| 106 | 12 | 1.0% | |
| 135 | 11 | 0.9% | |
| 120 | 11 | 0.9% | |
| 145 | 11 | 0.9% | |
| 166 | 10 | 0.8% | |
| 28 | 10 | 0.8% | |
| 83 | 10 | 0.8% | |
| Other values (270) | 1031 | 85.1% | |
| (Missing) | 64 | 5.3% |
| Value | Count | Frequency (%) | |
| -115 | 1 | 0.1% | |
| -2 | 1 | 0.1% | |
| 2 | 1 | 0.1% | |
| 5 | 1 | 0.1% | |
| 7 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 548 | 1 | 0.1% | |
| 408 | 1 | 0.1% | |
| 401 | 1 | 0.1% | |
| 376 | 1 | 0.1% | |
| 368 | 1 | 0.1% |
| Distinct count | 287 |
|---|---|
| Unique (%) | 23.7% |
| Missing | 64 |
| Missing (%) | 5.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 103.18308631211858 |
|---|---|
| Minimum | -115.0 |
| Maximum | 512.0 |
| Zeros | 2 |
| Zeros (%) | 0.2% |
| Memory size | 9.6 KiB |
Quantile statistics
| Minimum | -115 |
|---|---|
| 5-th percentile | -9.7 |
| Q1 | 39 |
| median | 103 |
| Q3 | 153 |
| 95-th percentile | 235 |
| Maximum | 512 |
| Range | 627 |
| Interquartile range (IQR) | 114 |
Descriptive statistics
| Standard deviation | 76.99454635 |
|---|---|
| Coefficient of variation (CV) | 0.7461934809 |
| Kurtosis | 0.7890005305 |
| Mean | 103.1830863 |
| Median Absolute Deviation (MAD) | 62.21558989 |
| Skewness | 0.6214442153 |
| Sum | 118351 |
| Variance | 5928.160167 |
| Value | Count | Frequency (%) | |
| 128 | 12 | 1.0% | |
| 142 | 11 | 0.9% | |
| 38 | 11 | 0.9% | |
| 31 | 11 | 0.9% | |
| 154 | 10 | 0.8% | |
| 161 | 10 | 0.8% | |
| -13 | 10 | 0.8% | |
| 152 | 10 | 0.8% | |
| 159 | 10 | 0.8% | |
| 46 | 10 | 0.8% | |
| Other values (276) | 1042 | 86.0% | |
| (Missing) | 64 | 5.3% |
| Value | Count | Frequency (%) | |
| -115 | 1 | 0.1% | |
| -37 | 1 | 0.1% | |
| -33 | 1 | 0.1% | |
| -28 | 2 | 0.2% | |
| -27 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 512 | 1 | 0.1% | |
| 372 | 1 | 0.1% | |
| 371 | 2 | 0.2% | |
| 366 | 1 | 0.1% | |
| 360 | 1 | 0.1% |
| Distinct count | 1124 |
|---|---|
| Unique (%) | 92.8% |
| Missing | 63 |
| Missing (%) | 5.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 112.97501132404182 |
|---|---|
| Minimum | 69.362 |
| Maximum | 186.111 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 9.6 KiB |
Quantile statistics
| Minimum | 69.362 |
|---|---|
| 5-th percentile | 96.3829 |
| Q1 | 100.033 |
| median | 109.518 |
| Q3 | 122.6705 |
| 95-th percentile | 141.3737 |
| Maximum | 186.111 |
| Range | 116.749 |
| Interquartile range (IQR) | 22.6375 |
Descriptive statistics
| Standard deviation | 15.39742937 |
|---|---|
| Coefficient of variation (CV) | 0.136290576 |
| Kurtosis | 0.70832187 |
| Mean | 112.9750113 |
| Median Absolute Deviation (MAD) | 12.485792 |
| Skewness | 0.8377851324 |
| Sum | 129695.313 |
| Variance | 237.0808311 |
| Value | Count | Frequency (%) | |
| 99.56 | 3 | 0.2% | |
| 109.75 | 2 | 0.2% | |
| 98.394 | 2 | 0.2% | |
| 113.888 | 2 | 0.2% | |
| 125.291 | 2 | 0.2% | |
| 100.071 | 2 | 0.2% | |
| 112.773 | 2 | 0.2% | |
| 105.007 | 2 | 0.2% | |
| 131.321 | 2 | 0.2% | |
| 140.6 | 2 | 0.2% | |
| Other values (1113) | 1127 | 93.1% | |
| (Missing) | 63 | 5.2% |
| Value | Count | Frequency (%) | |
| 69.362 | 1 | 0.1% | |
| 69.989 | 1 | 0.1% | |
| 70.896 | 1 | 0.1% | |
| 74.454 | 1 | 0.1% | |
| 77.177 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 186.111 | 1 | 0.1% | |
| 173.525 | 1 | 0.1% | |
| 168.057 | 1 | 0.1% | |
| 167.412 | 1 | 0.1% | |
| 166.489 | 1 | 0.1% |
| Distinct count | 966 |
|---|---|
| Unique (%) | 79.8% |
| Missing | 64 |
| Missing (%) | 5.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.491941586748038 |
|---|---|
| Minimum | 0.65 |
| Maximum | 6.479 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 9.6 KiB |
Quantile statistics
| Minimum | 0.65 |
|---|---|
| 5-th percentile | 1.1512 |
| Q1 | 1.7235 |
| median | 2.565 |
| Q3 | 3.1465 |
| 95-th percentile | 3.8892 |
| Maximum | 6.479 |
| Range | 5.829 |
| Interquartile range (IQR) | 1.423 |
Descriptive statistics
| Standard deviation | 0.8920811056 |
|---|---|
| Coefficient of variation (CV) | 0.3579863631 |
| Kurtosis | -0.09145697276 |
| Mean | 2.491941587 |
| Median Absolute Deviation (MAD) | 0.740790887 |
| Skewness | 0.3133593346 |
| Sum | 2858.257 |
| Variance | 0.795808699 |
| Value | Count | Frequency (%) | |
| 2.75 | 4 | 0.3% | |
| 2.17 | 4 | 0.3% | |
| 2.517 | 4 | 0.3% | |
| 2.509 | 4 | 0.3% | |
| 2.901 | 3 | 0.2% | |
| 3.157 | 3 | 0.2% | |
| 1.504 | 3 | 0.2% | |
| 1.69 | 3 | 0.2% | |
| 2.962 | 3 | 0.2% | |
| 1.368 | 3 | 0.2% | |
| Other values (955) | 1113 | 91.9% | |
| (Missing) | 64 | 5.3% |
| Value | Count | Frequency (%) | |
| 0.65 | 1 | 0.1% | |
| 0.685 | 1 | 0.1% | |
| 0.819 | 1 | 0.1% | |
| 0.855 | 1 | 0.1% | |
| 0.881 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 6.479 | 1 | 0.1% | |
| 5.445 | 1 | 0.1% | |
| 5.423 | 1 | 0.1% | |
| 5.333 | 1 | 0.1% | |
| 5.131 | 1 | 0.1% |
| Distinct count | 5 |
|---|---|
| Unique (%) | 0.4% |
| Missing | 63 |
| Missing (%) | 5.2% |
| Memory size | 9.6 KiB |
| Corporate | |
|---|---|
| Securitized/Collateralized | |
| Quasi & Foreign Government | |
| CASH | 1 |
| Value | Count | Frequency (%) | |
| Corporate | 783 | 64.7% | |
| Securitized/Collateralized | 187 | 15.4% | |
| Quasi & Foreign Government | 177 | 14.6% | |
| CASH | 1 | 0.1% | |
| (Missing) | 63 | 5.2% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | True |
| Contains non-words | True |
Length
| Max length | 26 |
|---|---|
| Mean length | 13.79355904 |
| Min length | 3 |
| Distinct count | 8 |
|---|---|
| Unique (%) | 0.7% |
| Missing | 63 |
| Missing (%) | 5.2% |
| Memory size | 9.6 KiB |
| Industrials | |
|---|---|
| Financial | |
| Quasi & Foreign Government | |
| Securitized | |
| Utility | |
| Other values (2) | 33 |
| Value | Count | Frequency (%) | |
| Industrials | 392 | 32.4% | |
| Financial | 263 | 21.7% | |
| Quasi & Foreign Government | 177 | 14.6% | |
| Securitized | 155 | 12.8% | |
| Utility | 128 | 10.6% | |
| Covered | 32 | 2.6% | |
| CASH | 1 | 0.1% | |
| (Missing) | 63 | 5.2% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | True |
| Contains non-words | True |
Length
| Max length | 26 |
|---|---|
| Mean length | 11.80759703 |
| Min length | 3 |
| Distinct count | 29 |
|---|---|
| Unique (%) | 2.4% |
| Missing | 63 |
| Missing (%) | 5.2% |
| Memory size | 9.6 KiB |
| Banking | |
|---|---|
| Utility | |
| Asset Backed | 111 |
| Real Estate | 105 |
| Insurance | 71 |
| Other values (23) |
| Value | Count | Frequency (%) | |
| Banking | 162 | 13.4% | |
| Utility | 128 | 10.6% | |
| Asset Backed | 111 | 9.2% | |
| Real Estate | 105 | 8.7% | |
| Insurance | 71 | 5.9% | |
| Government Guaranteed | 62 | 5.1% | |
| Supranational | 54 | 4.5% | |
| Telecommunications | 45 | 3.7% | |
| Commercial Mortgage Backed | 41 | 3.4% | |
| Consumer Goods | 38 | 3.1% | |
| Other values (18) | 331 | 27.3% | |
| (Missing) | 63 | 5.2% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | True |
| Contains non-words | True |
Length
| Max length | 26 |
|---|---|
| Mean length | 11.12303881 |
| Min length | 3 |
| Distinct count | 65 |
|---|---|
| Unique (%) | 5.4% |
| Missing | 63 |
| Missing (%) | 5.2% |
| Memory size | 9.6 KiB |
| Banking | |
|---|---|
| Government Guaranteed | 62 |
| ABS Miscellaneous ABS | 57 |
| Housing Association | 55 |
| Supranational | 54 |
| Other values (59) |
| Value | Count | Frequency (%) | |
| Banking | 162 | 13.4% | |
| Government Guaranteed | 62 | 5.1% | |
| ABS Miscellaneous ABS | 57 | 4.7% | |
| Housing Association | 55 | 4.5% | |
| Supranational | 54 | 4.5% | |
| Electric-Integrated | 47 | 3.9% | |
| ABS Utilities | 47 | 3.9% | |
| Life Insurance | 46 | 3.8% | |
| Commercial Mortgage Backed | 41 | 3.4% | |
| Non-Electric Utilities | 40 | 3.3% | |
| Other values (54) | 537 | 44.3% | |
| (Missing) | 63 | 5.2% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | True |
| Contains non-words | True |
Length
| Max length | 40 |
|---|---|
| Mean length | 16.20561519 |
| Min length | 3 |
| Distinct count | 428 |
|---|---|
| Unique (%) | 35.3% |
| Missing | 63 |
| Missing (%) | 5.2% |
| Memory size | 9.6 KiB |
| EIB | 22 |
|---|---|
| KFW | 19 |
| LLOYDS | 17 |
| HSBC | 15 |
| THAMES | 14 |
| Other values (422) |
| Value | Count | Frequency (%) | |
| EIB | 22 | 1.8% | |
| KFW | 19 | 1.6% | |
| LLOYDS | 17 | 1.4% | |
| HSBC | 15 | 1.2% | |
| THAMES | 14 | 1.2% | |
| GE | 13 | 1.1% | |
| RABOBK | 11 | 0.9% | |
| PPL | 11 | 0.9% | |
| AVLN | 10 | 0.8% | |
| EDF | 10 | 0.8% | |
| Other values (417) | 1006 | 83.1% | |
| (Missing) | 63 | 5.2% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 6 |
|---|---|
| Mean length | 4.609413708 |
| Min length | 1 |
| Distinct count | 688 |
|---|---|
| Unique (%) | 56.8% |
| Missing | 63 |
| Missing (%) | 5.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.41799041811846693 |
|---|---|
| Minimum | -1.736 |
| Maximum | 3.923 |
| Zeros | 1 |
| Zeros (%) | 0.1% |
| Memory size | 9.6 KiB |
Quantile statistics
| Minimum | -1.736 |
|---|---|
| 5-th percentile | 0.04935 |
| Q1 | 0.14175 |
| median | 0.31 |
| Q3 | 0.588 |
| 95-th percentile | 1.1723 |
| Maximum | 3.923 |
| Range | 5.659 |
| Interquartile range (IQR) | 0.44625 |
Descriptive statistics
| Standard deviation | 0.4035835023 |
|---|---|
| Coefficient of variation (CV) | 0.9655329041 |
| Kurtosis | 7.933361849 |
| Mean | 0.4179904181 |
| Median Absolute Deviation (MAD) | 0.2951590632 |
| Skewness | 1.422263031 |
| Sum | 479.853 |
| Variance | 0.1628796433 |
| Value | Count | Frequency (%) | |
| 0.14 | 7 | 0.6% | |
| 0.107 | 7 | 0.6% | |
| 0.093 | 7 | 0.6% | |
| 0.193 | 6 | 0.5% | |
| 0.085 | 6 | 0.5% | |
| 0.129 | 6 | 0.5% | |
| 0.166 | 6 | 0.5% | |
| 0.117 | 6 | 0.5% | |
| 0.221 | 6 | 0.5% | |
| 0.114 | 5 | 0.4% | |
| Other values (677) | 1086 | 89.7% | |
| (Missing) | 63 | 5.2% |
| Value | Count | Frequency (%) | |
| -1.736 | 1 | 0.1% | |
| -1.522 | 1 | 0.1% | |
| -0.963 | 1 | 0.1% | |
| -0.913 | 1 | 0.1% | |
| -0.841 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 3.923 | 1 | 0.1% | |
| 2.57 | 1 | 0.1% | |
| 2.25 | 1 | 0.1% | |
| 2.225 | 1 | 0.1% | |
| 2.023 | 1 | 0.1% |
| Distinct count | 11 |
|---|---|
| Unique (%) | 0.9% |
| Missing | 63 |
| Missing (%) | 5.2% |
| Memory size | 9.6 KiB |
| SENR | |
|---|---|
| SSEN | |
| SECR | 124 |
| SUB | 43 |
| T2 | 43 |
| Other values (5) | 41 |
| Value | Count | Frequency (%) | |
| SENR | 745 | 61.5% | |
| SSEN | 152 | 12.6% | |
| SECR | 124 | 10.2% | |
| SUB | 43 | 3.6% | |
| T2 | 43 | 3.6% | |
| JSUB | 22 | 1.8% | |
| T1 | 9 | 0.7% | |
| SSUB | 8 | 0.7% | |
| CASH | 1 | 0.1% | |
| UT2 | 1 | 0.1% | |
| (Missing) | 63 | 5.2% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 4 |
|---|---|
| Mean length | 3.825763832 |
| Min length | 2 |
| Distinct count | 966 |
|---|---|
| Unique (%) | 79.8% |
| Missing | 63 |
| Missing (%) | 5.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.4456506968641114 |
|---|---|
| Minimum | 0.0 |
| Maximum | 6.506 |
| Zeros | 1 |
| Zeros (%) | 0.1% |
| Memory size | 9.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1.11845 |
| Q1 | 1.671 |
| median | 2.519 |
| Q3 | 3.093 |
| 95-th percentile | 3.8443 |
| Maximum | 6.506 |
| Range | 6.506 |
| Interquartile range (IQR) | 1.422 |
Descriptive statistics
| Standard deviation | 0.8921982271 |
|---|---|
| Coefficient of variation (CV) | 0.3648101621 |
| Kurtosis | 0.03173751741 |
| Mean | 2.445650697 |
| Median Absolute Deviation (MAD) | 0.737456493 |
| Skewness | 0.3444171516 |
| Sum | 2807.607 |
| Variance | 0.7960176765 |
| Value | Count | Frequency (%) | |
| 2.801 | 4 | 0.3% | |
| 1.605 | 3 | 0.2% | |
| 2.472 | 3 | 0.2% | |
| 3.03 | 3 | 0.2% | |
| 3.145 | 3 | 0.2% | |
| 2.818 | 3 | 0.2% | |
| 2.723 | 3 | 0.2% | |
| 2.274 | 3 | 0.2% | |
| 1.671 | 3 | 0.2% | |
| 1.236 | 3 | 0.2% | |
| Other values (955) | 1117 | 92.2% | |
| (Missing) | 63 | 5.2% |
| Value | Count | Frequency (%) | |
| 0 | 1 | 0.1% | |
| 0.659 | 1 | 0.1% | |
| 0.699 | 1 | 0.1% | |
| 0.726 | 1 | 0.1% | |
| 0.798 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 6.506 | 1 | 0.1% | |
| 5.444 | 1 | 0.1% | |
| 5.442 | 1 | 0.1% | |
| 5.276 | 1 | 0.1% | |
| 5.119 | 1 | 0.1% |
First rows
| %_Weight | Accrued_Interest | Asset_Swap_Spread | Cash | Composite_Rating | Country | Coupon | Currency | Cusip | Description | Duration_To_Worst | Effective_Duration | Effective_Yield | Excess_Rtn_%_MTD | Face_Value | Illiquidity_Premium | ISIN | Maturity | OAS_vs_Govt | OAS_vs_Swap_ | Price | Prior_Month-End_%_Weight | Prior_Month-End_Accrued_Interest | Prior_Month-End_Asset_Swap_Spread | Prior_Month-End_Duration_To_Worst | Prior_Month-End_Effective_Duration | Prior_Month-End_Effective_Yield | Prior_Month-End_OAS_vs_Govt | Prior_Month-End_OAS_vs_Swap | Prior_Month-End_Price | Prior_Month-End_Yield_To_Worst | Sector_Level_1 | Sector_Level_2 | Sector_Level_3 | Sector_Level_4 | Ticker | TRR_%_MTD_LOC | Type | Yield_to_Worst | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 0.11658 | 0.091712 | 235.0 | 0.0 | BBB3 | GB | 2.875 | GBP | 'AL319313' | AA Bond Co Limited | 3.233 | 3.274 | 4.195 | 0.068 | 700.0 | NaN | XS1529687870 | 1/31/2022 | 280.0 | 243.0 | 97.37418 | 0.11689 | 0.009 | 285.0 | 3.256 | 3.266 | 4.221 | 331.0 | 294.0 | 97.277 | 4.221 | Securitized/Collateralized | Securitized | Asset Backed | ABS Automobile | AABOND | 0.184 | SSEN | 4.195 |
| 1 | 0.04003 | 0.074728 | 267.0 | 0.0 | BBB3 | GB | 2.750 | GBP | 'AO236287' | AA Bond Co Limited | 4.570 | 4.581 | 4.181 | 0.071 | 250.0 | NaN | XS1645315620 | 7/31/2023 | 318.0 | 282.0 | 93.62339 | 0.04012 | 0.007 | 267.0 | 4.593 | 4.604 | 4.204 | 318.0 | 282.0 | 93.497 | 4.254 | Securitized/Collateralized | Securitized | Asset Backed | ABS Automobile | AABOND | 0.207 | SSEN | 4.231 |
| 2 | 0.09522 | 0.321009 | 323.0 | 0.0 | BBB3 | GB | 4.875 | GBP | 'AT538379' | AA Bond Co Limited | 5.125 | 5.144 | 4.673 | 0.042 | 550.0 | NaN | XS1856940462 | 7/31/2024 | 361.0 | 327.0 | 100.99960 | 0.09546 | 0.202 | 323.0 | 5.148 | 5.168 | 4.688 | 360.0 | 327.0 | 100.923 | 4.688 | Securitized/Collateralized | Securitized | Asset Backed | ABS Automobile | AABOND | 0.193 | SSEN | 4.673 |
| 3 | 0.09359 | 0.170353 | 433.0 | 0.0 | BBB3 | GB | 6.269 | GBP | 'EJ733791' | AA Bond Co Limited | 5.676 | 5.524 | 4.677 | 0.107 | 500.0 | NaN | XS0949169923 | 7/31/2025 | 449.0 | 418.0 | 109.37700 | 0.09376 | 0.017 | 335.0 | 5.698 | 5.728 | 4.705 | 354.0 | 324.0 | 109.232 | 4.705 | Securitized/Collateralized | Securitized | Asset Backed | ABS Automobile | AABOND | 0.273 | SECR | 4.677 |
| 4 | 0.03539 | 0.142628 | 137.0 | 0.0 | BBB3 | GB | 4.249 | GBP | 'EJ944681' | AA Bond Co Limited | 1.867 | 1.891 | 3.443 | 0.202 | 200.0 | NaN | XS0996575378 | 7/31/2020 | 173.0 | 136.0 | 103.41360 | 0.03545 | 0.014 | 244.0 | 1.890 | 1.892 | 3.549 | 278.0 | 243.0 | 103.249 | 3.549 | Securitized/Collateralized | Securitized | Asset Backed | ABS Automobile | AABOND | 0.284 | SSEN | 3.443 |
| 5 | 0.13906 | 0.082880 | 60.0 | 0.0 | AA1 | US | 3.050 | GBP | '037833BJ' | Apple Inc. | 9.374 | 9.495 | 2.182 | 0.893 | 750.0 | NaN | XS1269175466 | 7/31/2029 | 74.0 | 59.0 | 108.42700 | 0.13809 | 0.008 | 70.0 | 9.383 | 9.504 | 2.299 | 83.0 | 69.0 | 107.261 | 2.299 | Corporate | Industrials | Technology & Electronics | Tech Hardware & Equipment | AAPL | 1.156 | SENR | 2.182 |
| 6 | 0.10107 | 0.097826 | 98.0 | 0.0 | AA1 | US | 3.600 | GBP | '037833BK' | Apple Inc. | 16.721 | 16.964 | 2.577 | 1.287 | 500.0 | NaN | XS1269176191 | 7/31/2042 | 82.0 | 91.0 | 118.20210 | 0.09992 | 0.010 | 105.0 | 16.677 | 16.912 | 2.669 | 90.0 | 98.0 | 116.420 | 2.669 | Corporate | Industrials | Technology & Electronics | Tech Hardware & Equipment | AAPL | 1.606 | SENR | 2.577 |
| 7 | 0.04264 | 0.183562 | 12.0 | 0.0 | AAA | DE | 1.000 | GBP | 'AP291624' | Aareal Bank AG | 1.785 | 1.798 | 1.201 | 0.028 | 250.0 | NaN | XS1692489237 | 06/04/2020 | 48.0 | 11.0 | 99.63313 | 0.04279 | 0.159 | 14.0 | 1.809 | 1.822 | 1.239 | 48.0 | 13.0 | 99.560 | 1.243 | Securitized/Collateralized | Covered | Covered Bonds | Mortgage Covered Bonds | AARB | 0.098 | SECR | 1.205 |
| 8 | 0.10950 | 0.747945 | 63.0 | 0.0 | BBB1 | BE | 1.750 | GBP | 'AN612936' | Anheuser-Busch InBev N.V./S.A. | 6.088 | 6.188 | 2.094 | 0.269 | 650.0 | NaN | BE6295391914 | 03/07/2025 | 96.0 | 65.0 | 97.83852 | 0.10950 | 0.705 | 67.0 | 6.108 | 6.210 | 2.158 | 100.0 | 69.0 | 97.442 | 2.170 | Corporate | Industrials | Consumer Goods | Beverage | ABIBB | 0.447 | SENR | 2.105 |
| 9 | 0.11594 | 0.480822 | 99.0 | 0.0 | BBB1 | BE | 2.250 | GBP | 'AN612976' | Anheuser-Busch InBev N.V./S.A. | 9.380 | 9.629 | 2.615 | 0.613 | 700.0 | NaN | BE6295393936 | 5/24/2029 | 117.0 | 102.0 | 96.44888 | 0.11544 | 0.425 | 105.0 | 9.390 | 9.644 | 2.700 | 124.0 | 109.0 | 95.657 | 2.719 | Corporate | Industrials | Consumer Goods | Beverage | ABIBB | 0.882 | SENR | 2.632 |
Last rows
| %_Weight | Accrued_Interest | Asset_Swap_Spread | Cash | Composite_Rating | Country | Coupon | Currency | Cusip | Description | Duration_To_Worst | Effective_Duration | Effective_Yield | Excess_Rtn_%_MTD | Face_Value | Illiquidity_Premium | ISIN | Maturity | OAS_vs_Govt | OAS_vs_Swap_ | Price | Prior_Month-End_%_Weight | Prior_Month-End_Accrued_Interest | Prior_Month-End_Asset_Swap_Spread | Prior_Month-End_Duration_To_Worst | Prior_Month-End_Effective_Duration | Prior_Month-End_Effective_Yield | Prior_Month-End_OAS_vs_Govt | Prior_Month-End_OAS_vs_Swap | Prior_Month-End_Price | Prior_Month-End_Yield_To_Worst | Sector_Level_1 | Sector_Level_2 | Sector_Level_3 | Sector_Level_4 | Ticker | TRR_%_MTD_LOC | Type | Yield_to_Worst | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1201 | NaN | NaN | NaN | NaN | A1 | GB | 3.176 | GBP | BRTB97DX4 | Local Space Ltd A 3.176% 31/03/57 | NaN | 21.89 | NaN | NaN | NaN | 68.0 | NaN | 31/03/2057 | NaN | NaN | 98.42 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 1202 | NaN | NaN | NaN | NaN | AA2 | GB | 2.525 | GBP | BRTAXWE21 | St Edmunds Hall OX 2.525% 16/06/67 | NaN | 27.60 | NaN | NaN | NaN | 40.0 | NaN | 16/06/2067 | NaN | NaN | 97.46 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 1203 | NaN | NaN | NaN | NaN | A3 | GB | 0.010 | GBP | BRTB87S19 | European Invest SNR Note 0.1% 31/03/36 | NaN | 9.35 | NaN | NaN | NaN | 60.0 | NaN | 31/03/2036 | NaN | NaN | 109.77 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 1204 | NaN | NaN | NaN | NaN | AA3 | GB | 2.430 | GBP | BPM0W7PP7 | Single platform 2.43% 31/12/31 | NaN | 11.21 | NaN | NaN | NaN | 93.0 | XS1683357096 | 31/12/2031 | NaN | NaN | 97.33 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 1205 | NaN | NaN | NaN | NaN | BBB2 | GB | 4.608 | GBP | BRTDA9WF2 | Telecom Credit B 4.608% 27/10/27 | NaN | 7.50 | NaN | NaN | NaN | 222.0 | NaN | 27/10/2027 | NaN | NaN | 101.00 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 1206 | NaN | NaN | NaN | NaN | A1 | GB | 3.584 | GBP | BRTD9MWM0 | Knight Dragon 3.584% 20/10/28 | NaN | 8.48 | NaN | NaN | NaN | 165.0 | NaN | 20/10/2028 | NaN | NaN | 99.78 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 1207 | NaN | NaN | NaN | NaN | A1 | GB | 2.500 | GBP | Z92HKY1H0 | Income Contingent A2 2.5% 24/07/56 | NaN | 23.98 | NaN | NaN | NaN | 79.0 | XS1722900864 | 24/07/2056 | NaN | NaN | 93.77 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 1208 | NaN | NaN | NaN | NaN | AA3 | GB | 0.000 | GBP | BRT7F86Y0 | Lagoon Park Capital 0% 16/01/42 | NaN | 12.01 | NaN | NaN | NaN | NaN | XS1481927587 | 16/01/2042 | NaN | NaN | 72.69 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 1209 | NaN | NaN | NaN | NaN | BBB1 | GB | 4.335 | GBP | BRTG6B029 | Insite Poster Group 4.335% 20/04/28 | NaN | 7.90 | NaN | NaN | NaN | 169.0 | NaN | 20/04/2028 | NaN | NaN | 101.93 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 1210 | NaN | NaN | NaN | NaN | AA3 | GB | 3.210 | GBP | BPM1HR018 | Northumbria Health NHFT 3.21% GBP 31/03/2043 | NaN | 9.75 | NaN | NaN | NaN | 55.0 | NaN | 31/03/2043 | NaN | NaN | 101.54 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |